<?

$menuBody = "<?

\$thisMdl        = \"".$modulName."\";
\$modulNumber    = \"".$menuNumber."\";

\$entryBoxStyle  = \" style='width:110;height:40;
                           font-size:100%;
                           font-weight:bold;' \";

\$GHtml       = new CGHtml;
\$GJs         = new CGJavascript;
\$Misc        = new Misc;
\$CLFetchers  = new CLFetchers;

\$SourceDb   = new Composer;
\$SourceDb   = \$SourceDb->init(\"db\");

\$SourceDb->add(\"srcDbHdr\",      \"".$menuBodySrcDbHdr."\");
\$SourceDb->add(\"srcDbDtl\",      \"".$menuBodySrcDbDtl."\");

//check if the user has the entry priv
if(\$UID->getPrivsByNumber( \$modulNumber, _ENTRY_RIGHTS) > 0){

	//check entry
	\$bodyPart	=	\"<tr>\\n\".
							\"  <td> \".\$GHtml->formInputButton(\"<font size='5'>Entry</font>\", // The label
        							                           \"entry\",                       // var Name
        							                           \"entry\",                       // var value
        							                           \$entryBoxStyle).\" </td>\\n\";    // var properties
}else{

	\$bodyPart	=	\"<tr>\\n\";
}

\$optPrivs = \"\";
if(\$UID->getPrivsByNumber( \$modulNumber, _VIEW_RIGHTS) > 0){

	\$optPrivs .=	\"  <td> \".\$GHtml->formInputButton(\"<font size='5'>View</font>\", // The label
          							                           \"view\",                       // var Name
          							                           \"View\",                       // var value
          							                           \$entryBoxStyle).\" </td>\\n\";   // var properties
}
if(\$UID->getPrivsByNumber( \$modulNumber, _MODIFY_RIGHTS) > 0){

	\$optPrivs .=	\"  <td> \".\$GHtml->formInputButton( \"<font size='5'>Modify</font>\", // The label
            							                          \"modify\",                       // var Name
            							                          \"Modify\",                       // var value
            							                          \$entryBoxStyle).\" </td>\\n\";     // var properties
}
if(\$UID->getPrivsByNumber( \$modulNumber, _APPROVED_RIGHTS) > 0){

	\$optPrivs	.=	\"  <td> \".\$GHtml->formInputButton( \"<font size='5'>Approve</font>\", // The label
            							                          \"approve\",                       // var Name
            							                          \"Approve\",                       // var value
            							                          \$entryBoxStyle).\" </td>\\n\";      // var properties
}
if(\$UID->getPrivsByNumber( \$modulNumber, _DELETE_RIGHTS) > 0){

	\$optPrivs	.=	\"  <td> \".\$GHtml->formInputButton( \"<font size='5'>Cancel</font>\", // The label
            							                          \"cancel\",                       // var Name
            							                          \"Cancel\",                       // var value
            							                          \$entryBoxStyle).\" </td>\\n\";     // var properties
}
if(\$UID->getPrivsByNumber( \$modulNumber, _EDIT_RIGHTS) > 0){

	\$optPrivs	.=	\"  <td> \".\$GHtml->formInputButton( \"<font size='5'>Delete</font>\", // The label
            							                          \"delete\",                       // var Name
            							                          \"Delete\",                       // var value
            							                          \$entryBoxStyle).\" </td>\\n\";     // var properties
}


if(\$_POST[\"range_period1\"]){
 	\$condt  = \" AND TR_DATE >= TO_DATE('\" .\$_POST[\"range_period1\"]. \" ',
 	                                  'dd-mm-yyyy') \".
 	          \" and TR_DATE <= to_date('\" .\$_POST[\"range_period2\"]. \"',
 	                                  'dd-mm-yyyy')\";
}else{
 	\$condt  = \" AND TR_DATE<add_months(TO_DATE('\".\$_SESSION[\"sysPeriode\"]. \"',
                                             'MM-YYYY'),1) \".
 	          \" and TR_DATE>= TO_DATE('\".\$_SESSION[\"sysPeriode\"].\"',
 	                                           'MM-YYYY')\";
}


//check if criteria is null then default is by entried
//process criteria
switch(\$_POST[\"criterialist\"]){

	case \"pending\":
		\$partCriteria = \"WHERE  STATUS='\"._NOT_ACTIVE.\"' \";
		//echo \$query;
		\$sts[1]  = \"selected\";

		break;
	case \"approved\":
		\$partCriteria = \"WHERE  STATUS='\"._ACTIVE.\"' \";
		\$sts[2]  = \"selected\";

		break;
	case \"canceled\":
		\$partCriteria = \"WHERE  STATUS='\"._CANCELED.\"' \";
		\$sts[3]  = \"selected\";

		break;
	default:
		\$partCriteria = \"WHERE  STATUS<>'\"._MONTHLY_UPDATE.\"' \";
		//echo \$query;
		\$sts[0]  = \"selected\";
}

//lets init the first table
echo  \$GJs->includeThis(_TYPE_CSS,\"/ecs/myMenu.css\").
      \$GJs->includeThis(_TYPE_JS ,\"/ecs/javascript/GMisc.js\").
      \$GJs->includeThis(_TYPE_JS ,\"/ecs/javascript/GAjax.js\").

      /**
      * This module js
      */
      \$GJs->includeThis(_TYPE_JS ,\"/ecs/".$menuName."_".$menuNumber."/javascript/misc.js\").
      \$GJs->includeThis(_TYPE_JS ,\"/ecs/".$menuName."_".$menuNumber."/javascript/ajax.js\").
      \$GJs->stopRKey().

			\"<br/><br/><br/><br/><br/>\\n\".
			\"<form action=# name='crtList' method=post>\\n\".
			\"<table border='1' class='dedeq'>\\n\".
			\"<tr>\\n\".
			\" <td>Range period1</td><td> \".\$GHtml->formInput(\"range_period1\",
                                                       \$_POST[\"range_period1\"],
                                                       \$Misc->stdNumStyle100()).\"</td>\\n\".

      \" <td>Range period2</td><td>\".\$GHtml->formInput(\"range_period2\",
                                                      \$_POST[\"range_period2\"],
                                                      \$Misc->stdNumStyle100()).\"</td>\\n\".

      \" <td><select name='criterialist' align='left' onchange='this.form.submit()' >\".
  		\"  <option value=''	\$sts[0]> </option>\".
  		\"  <option value='pending'  \$sts[1]>By Pending</option>\".
  		\"  <option value='approved' \$sts[2]>By Approved</option>\".
  		\"  <option value='canceled' \$sts[3]>By Canceled</option>\".
  		\" </select></td>\".
			\" <td colspan='2'><input type='submit' name='criteria' 	value='Criteria'  align='left' style='width:100%; height:100%'></td></tr>\\n\".
			\"<tr>\\n\".
			\"  <input      type='hidden' name='view' 	value='View'>\\n\".
			\"  <input      type='hidden' name='radioview' 	value='\".\$_POST[\"radioview\"].\"'>\\n\".
			\"</form>\\n\".
			\"</tr>\\n\".
			\"</table>\\n\".
			\"<table border='1'>\\n\".
			\"<form action=".$menuName."_".$menuNumber."/viewdboredit.php method=post>\\n\".
			\$bodyPart.
			\$optPrivs.
			\"</td>\\n\".
			\"</tr>\\n\".
			\"</table>\\n\";

/**
* connect to db to retrieve data with system period as the range
*
*/
\$Db = new ".$dbTech.";
\$Db->init(\$_SESSION[\"ORCL\"],
           \$_SESSION[\"OPASS\"],
           \$_SESSION[\"SID\"],
           _NO_COMMENT);

if (\$Db->connect()) {

  \$srcDbHdr = \"".$menuBodySrcDbHdr."\";

  \$CLFetchers->fetchLstTransaction(\$Db,
            	                     \$partCriteria . \$condt,
            	                     \$srcDbHdr,
            	                     \$nrows,
            	                     \$res);

  echo  \"<table border='1' class='dedeq'>\\n\";

  for (\$i = 0; \$i < \$nrows; \$i++) {

    switch(\$res[\"STATUS\"][\$i]){

      case _NOT_ACTIVE:

        \$stsType = \"PENDING\";
        break;

      case _ACTIVE:

        \$stsType = \"APPROVED\";
        break;

      case _CANCELED:

        \$stsType = \"CANCELED\";
        break;

      default:
        \$stsType = \"ERROR!!!\";
    }

    \$stdPropRow = \$GJs->jsOnMouseOver(\"GMisc.chgStyle(\\\"\$i\\\",\\\"sBlue\\\");\") .
                  \$GJs->jsOnMouseOut (\"GMisc.chgStyle(\\\"\$i\\\",\\\"sWhite\\\");\");

    \$JID  = \$res[\"JOB_ID\"][\$i];

    echo  \"<tr id='\$i' \".\$stdPropRow.\">\\n\".

         	  \"<td> \".\$GHtml->formRadio(\"radioview\",
         	                            \$JID,
         	                            _NO_PROPERTIES).\"      </td>\\n\".

         	  \"<td> \".\$GHtml->formCheckBox(\"selbox[]\",
             	                           \$JID,
             	                           _NO_PROPERTIES).\"  </td>\\n\".

          \"</tr>\\n\";

  }

  echo  \"</table>\\n\".
  			\"<br/>\\n\".
  			\"</form>\\n\".
  			\"</div>\\n\";

  \$Db->dc();
}else{

  \$Misc->usrDie(_DB_CONN_ERROR);
}

session_commit();

?> ";

?>